SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 51154: Excel abends when you use IntelliSense in the VBA IDE of Excel

DetailsAboutRate It

You might receive errors or MS Excel might abend when you use the IntelliSense IDE object browser in the VB IDE while running the 64-bit edition of Excel with SAS® Financial Management 5.3 Management. If this problem occurs, try the following tasks:

  1. Close Excel.
  2. Change directory to the following:

    C:\Program Files\SASHome\x86\SASFinancialManagementAddinforMicrosoftExcel\5.3

  3. Run the following command:

    C:\windows\Microsoft.NET\Framework64\v4.0.30319\regasm /tlb SASSESExcelAddIn.dll

Sometimes Excel caches a copy of the TLB file. If so, the problem will still occur after you perform the steps above. In this case, perform the following additional steps:

  1. Open the form.
  2. From Excel, press Alt+F11 to display the Development IDE.
  3. From the menu select Tools ► References. Deselect SASSESExcelAddin and click OK.
  4. Select Tools ► References.
  5. Click Browse and navigate to the following location:

    C:\Program Files\SASHome\x86\SASFinancialManagementAddinforMicrosoftExcel\5.3.

  6. Select SASSESExcelAddin.tlb and click OK.
  7. Click Save form.

Performing the steps above should remove cached information from any TLB file.

Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Financial ManagementMicrosoft® Windows® for x645.3_M19.3 TS1M2
Microsoft Windows 8 Enterprise 32-bit5.3_M19.3 TS1M2
Microsoft Windows 8 Enterprise x645.3_M19.3 TS1M2
Microsoft Windows 8 Pro 32-bit5.3_M19.3 TS1M2
Microsoft Windows 8 Pro x645.3_M19.3 TS1M2
Microsoft Windows Server 2008 R25.3_M19.3 TS1M2
Microsoft Windows Server 2008 for x645.3_M19.3 TS1M2
Microsoft Windows Server 2012 Datacenter5.3_M19.3 TS1M2
Microsoft Windows Server 2012 Std5.3_M19.3 TS1M2
Windows 7 Enterprise x645.3_M19.3 TS1M2
Windows 7 Professional x645.3_M19.3 TS1M2
64-bit Enabled AIX5.3_M19.3 TS1M2
64-bit Enabled Solaris5.3_M19.3 TS1M2
HP-UX IPF5.3_M19.3 TS1M2
Linux for x645.3_M19.3 TS1M2
Solaris for x645.3_M19.3 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.